UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Mzb80bsss6UDs71skw71sx1NRBfQNQGRqcpU/s6wkg='
WHERE
key_id = 'c7e67ebddc85eb77a93214aa58c14bd3962a8c6ef1449d3f05bf1bb92a228e98'
AND (
token = '3Mzb80bsss6UDs71skw71sx1NRBfQNQGRqcpU/s6wkg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)