UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ho7u1qrfXv+soZUs7e8beUaSRNJjxsnU8qk1KgGg1yE='
WHERE
key_id = '759c78d0e8ff2a63c8fd1d0a1657b9e74082379078a988f804704f1234fa1787'
AND (
token = 'ho7u1qrfXv+soZUs7e8beUaSRNJjxsnU8qk1KgGg1yE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)