SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5e4b019c2052b2438b241231a527548a1697b0b994a8ac3d3932d13966be50c9' 
  AND token = 'FxW57VEHwWLMk7pfLiHINaHYlj64ClXzbbR2E4Uuaig=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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