UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rgbfvzaCmHMaRmhZ9K7RE7317+at6LHIX7avYtob4nU='
WHERE
key_id = '112307c37a3b36bd15dc87dceb167d6b4c20dc1aa8253ccc23e1de54c560cbe3'
AND (
token = 'rgbfvzaCmHMaRmhZ9K7RE7317+at6LHIX7avYtob4nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)