UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Sf95VXYCxwT+FE2vYTDQwOXUBd71Ac77B/OXb6BRiW8=' 
WHERE 
  key_id = '077e3987ced37d6cd1397349a59422be9d9f3acb0f5dab7c96b5ab2bcf5c9b3a' 
  AND (
    token = 'Sf95VXYCxwT+FE2vYTDQwOXUBd71Ac77B/OXb6BRiW8=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047