UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LnnVrOG/PG3PdI9Q7LwtKFjufhiS0t6YD2HTk7yYHU='
WHERE
key_id = '658a8353f2662c80ff0ecc2034a11d6c231c1f6d6dd4b639525be0ce185174a2'
AND (
token = '6LnnVrOG/PG3PdI9Q7LwtKFjufhiS0t6YD2HTk7yYHU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)