SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2a80e55ad4f9f07f293e89a021a70ba6378cf53e5130ea08600d872c8c9a6108' 
  AND token = '+xgwYrVfE4rFYa24zFTIbSd1D4FZU0RA02QnF8//kGw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00017

JSON explain

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