UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZ8FDn7g5YhMFcUwWENB1OZY3Drv/Jsq7CRYVoVmYfw='
WHERE
key_id = 'e94f7ea3b6ec71c9dcbd2753cf90cd135f370119ec12024b5e5cea0cd85743e7'
AND (
token = 'yZ8FDn7g5YhMFcUwWENB1OZY3Drv/Jsq7CRYVoVmYfw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)