SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd5ea8302dc1462233029d332c9650a686a95e6f27a55ad09bae0c8775ef658aa' 
  AND token = 'ZBoQ/OgGpFDR+/A5vwNX78XMpiM/dYXMw3A4/5uZ+P8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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