SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '30f5ef9e4dd174fabc4c5f46e4ece4421f6807d972babb24853059d23d3a1e7a' 
  AND token = '0WqXAC1IRW8SdQyh6sRkgfmOYaPR+qnF4Vd5cRdDewA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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