UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xfiEbX/U5eaZ+EprCDIyXn3St3+iEdcXGIU7+CktS6Y='
WHERE
key_id = 'c041fbb9e1658e9046610b4ac9bb773fab26128f150b8e8ec24355dbb24aac40'
AND (
token = 'xfiEbX/U5eaZ+EprCDIyXn3St3+iEdcXGIU7+CktS6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)