UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/UPVfE1EP5J2fo61yIZkxAFda3APS2nQsloJboY6zzU='
WHERE
key_id = '29f244321c3c49752acfe2b9dbf3d60eec27da62db90fd45353a922b54dfea71'
AND (
token = '/UPVfE1EP5J2fo61yIZkxAFda3APS2nQsloJboY6zzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)