SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '34ef97fee0c60de1b93b86b4911af4dc21a67c22a459564a890b53bc4808e33f' 
  AND token = 'j9VXhr24IO9X5KoeA4fkefKk5eWGg6N0gV3I+2ghyrA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}