SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e694faf7c8d6a78c347fad6fa6bd493c1156f1797f763f21849b0a26c36f74c9' 
  AND token = 'xgBSP/7x4nOqRxOHnPjkCO+0UH1d0D8fx+N3IgHsB78=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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