UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lWiTf0kgEo4AtL/ZUFwVKd5thK8qxTx1rX4XAIHGHjc='
WHERE
key_id = '54db7f05e4b83e2cf5c867d0befa17c5f9fe799e3253cf90054e6544577db744'
AND (
token = 'lWiTf0kgEo4AtL/ZUFwVKd5thK8qxTx1rX4XAIHGHjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)