SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1cc1bef03a2d62fc8ca66c7cbc18891fe3b5bc1c54312aa619b40a0b428a65eb' 
  AND token = 'LLPVHDk3nLtjVTZrib4X7oD93LVILHH16Wp1ahhn9mI=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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