UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEjZ2cemBJLqJDc/v3FNxE5dISm0fo9svPALhm6yVS4='
WHERE
key_id = '573ccc255377c25a22c607e48091cc00730f85dd5b427896e61e67fb9ccc4b54'
AND (
token = 'gEjZ2cemBJLqJDc/v3FNxE5dISm0fo9svPALhm6yVS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)