UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'heqz+0SsOonN+1imvbSzQqtY3QsNmM/xs2ievm5Mpqg='
WHERE
key_id = 'b348246bb257df75fc2c7b26689fec781ebb10a751df9dbbbfc0b2913f474082'
AND (
token = 'heqz+0SsOonN+1imvbSzQqtY3QsNmM/xs2ievm5Mpqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)