UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pjQKhYxhLhNZ/zkUE6Ac83P4PqCa5rptq5FRewFHum8='
WHERE
key_id = 'd6bbcb707eca2ef3bfdc1e21aa6a591338cd29f56bf991bb737359e31a4d15eb'
AND (
token = 'pjQKhYxhLhNZ/zkUE6Ac83P4PqCa5rptq5FRewFHum8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)