UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hBiI3Rp0NaKq0XE7+cv5Y/ovxjZ0yxVHZLz+0cDxNP8='
WHERE
key_id = 'c6a2b00afe113bfd0091c2b4853af5a0faa053e204fc660f9eadbef65fb3c2b4'
AND (
token = 'hBiI3Rp0NaKq0XE7+cv5Y/ovxjZ0yxVHZLz+0cDxNP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)