UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I9tARhtQfOBOCJ2YZnOqCK4LF4nc6mVTdNsmsn0DQek='
WHERE
key_id = '8d47536d4a2dffdb14b4d484d261cda05332db3b5b85625faada6659f04853f6'
AND (
token = 'I9tARhtQfOBOCJ2YZnOqCK4LF4nc6mVTdNsmsn0DQek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)