UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z4bTaC7yBxFX32q2kPREHUtG/UyWkG8p/jiPAE+bK4o='
WHERE
key_id = '89772c5823ab35d4a546a418c9e65390a38376cf022b67f653ea9c40a50240e9'
AND (
token = 'Z4bTaC7yBxFX32q2kPREHUtG/UyWkG8p/jiPAE+bK4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)