SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '0c802ad6ac0a8f51cc6d3d47a845bdad97fc99d91f5bd0431e1214bb290d1dfa' 
  AND token = 'LoK9oPkJKg8F30icmcAR3mNWfYadJCDuo49/Y6hS5uQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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