UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'chNlvkJJjMf6HyTFELekk0ACIdFixOKxErAxP5SzKcM='
WHERE
key_id = '28da73671118f4fecf0aa4a855bfb87f3bca6b875b22f5cd46d9489ba8f1e1fc'
AND (
token = 'chNlvkJJjMf6HyTFELekk0ACIdFixOKxErAxP5SzKcM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)