UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DG1pYwqVbQFkArIbDAxHTEMKH0ks2qkiQ1SSlNlGJ00='
WHERE
key_id = 'bc16a1c7462792bb0466df29bfd001ccb9ffdd9664bee18ca4ee05bdd2bcc802'
AND (
token = 'DG1pYwqVbQFkArIbDAxHTEMKH0ks2qkiQ1SSlNlGJ00='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)