UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'x8iFU6TJqFXjn6qXyUNoE+azzMVxAhFh7QdtSZ9Rhwg=' 
WHERE 
  key_id = '7b6f744949305cbff50bbf4d8da2374e426985c3611cd5b96b9f884e0ac68bfe' 
  AND (
    token = 'x8iFU6TJqFXjn6qXyUNoE+azzMVxAhFh7QdtSZ9Rhwg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020