SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd18b5834a2237c0c913517090e5e5b8b54c447123f930581fe010d90348728fc' 
  AND token = 'x+CSWQ70qLalDjvNNuI6sD7SX8pJ7w8UqEdCJZmVr/c=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

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