UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVjts4HLx0RYj7huQXfYRqCRxnW9zpQdQkDvjspgVDU='
WHERE
key_id = '8ce96c184fcc8f269e7182fcf5ac40f0d5f5cbcfc6cec224f16f6db603f39270'
AND (
token = 'ZVjts4HLx0RYj7huQXfYRqCRxnW9zpQdQkDvjspgVDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)