UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NH8tyMwIIQogmbWl20C/nheQfbVksR8wCRiK44J/UAU='
WHERE
key_id = '4218debe1d86d96257f35f4ba8c510c3a81004d2cf25a653e3b7b68fd74b1847'
AND (
token = 'NH8tyMwIIQogmbWl20C/nheQfbVksR8wCRiK44J/UAU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)