UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QEuxv7GKuJu1XzeIxjGwKio2rrv9hVxidBFViMrNvvU='
WHERE
key_id = 'c78f08b4582c419ca3af59a696b3de8110c76acdfd01d93eaa3e7ad62a9a06fc'
AND (
token = 'QEuxv7GKuJu1XzeIxjGwKio2rrv9hVxidBFViMrNvvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)