SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '972e7047829507265237b5927ce63f91d6d70483c2eda935f0757549788326eb' 
  AND token = '5nNIrBFLjoUC31GMK8vT9m4rhPZalR+udZWx5hfYiZo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00022

JSON explain

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