UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TNGoU7dKqCqtAUri8H9Oz5fAfB4rOqYbQk9aWutzVIo='
WHERE
key_id = '0e1fc8d49d16a359f1e573d65ad3d36bce55a80328e9af5fa01015aa5bcdf9a1'
AND (
token = 'TNGoU7dKqCqtAUri8H9Oz5fAfB4rOqYbQk9aWutzVIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)