UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AoBdjjqVQSwLPEY7NV0InQ67clRLDBcgqlHbyKrxguU='
WHERE
key_id = 'c0edd3393dd3402abd4e6f5178d9f21ff9703748717ceddf131d598f4b607b09'
AND (
token = 'AoBdjjqVQSwLPEY7NV0InQ67clRLDBcgqlHbyKrxguU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)