SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '03d16541dae33c05f627128ec31a94554df79e5622aa941834fecc73b7d864e7' 
  AND token = 'Pn1y9F4FD8AiP0SLr3mI1VlI3Y/KxNaE5X2rQXICGwM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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