SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd127097c8b1fcbdc9dfd7e2316bde3e33b2e8382e6b3e6614c84d575b4e6b7f6' 
  AND token = 'WEzcloXo3ur5j7jP+cds8TAY5/oBtLaa9rbu/mPjNb8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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