UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lYrgq0U1kZDP2U/kPi38MCjHFUVRDrJKiRRrEti1IxM='
WHERE
key_id = 'ea0b9a601c56c3f021c071ff6b042b7daafa17c3f4917fe245bb249c914a5651'
AND (
token = 'lYrgq0U1kZDP2U/kPi38MCjHFUVRDrJKiRRrEti1IxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)