UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XNHrV5RiSWjdh/8wqHivT4J/Y76YvmmzhK8dJDfwp8='
WHERE
key_id = '8e32fda4d82cf3fd28393eb490c735ee149a58e17e5b15171388b19e88c81246'
AND (
token = '/XNHrV5RiSWjdh/8wqHivT4J/Y76YvmmzhK8dJDfwp8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)