SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ef49c7b0a4519401e58ea567f1060f9459acf5deb9b5383a81e974e3e0013668' 
  AND token = 'wpBWJdbtG8PAqHOW1BqISOOCzACeumr4Qh8aVoI75nI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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