UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Tg6ZQ7/HX3WWd6rDytM8P0vC+CIjCy4zVJZ3EEcPbmw=' 
WHERE 
  key_id = '8217e83d0fdc378dbaebd8b78b6d2de94323e974e1b6314e0f328c38e2abd31c' 
  AND (
    token = 'Tg6ZQ7/HX3WWd6rDytM8P0vC+CIjCy4zVJZ3EEcPbmw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021