UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fceHXkV+Jf4U7sElF8q5acpT+fPm+4aZdrNYrX28MF8='
WHERE
key_id = '347bc50d268074e6b692f94d3dc1d70c6718b1e158929741e502bd4d08395ba1'
AND (
token = 'fceHXkV+Jf4U7sElF8q5acpT+fPm+4aZdrNYrX28MF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)