SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5feadec19213e667e744659af3fc3237395e0b57427e941d68c336191c9139ab' 
  AND token = 'PjMu4F3zhEOYd7B/9WX5Uqw1P1g0zI74t+OfLk9Dag4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00042

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}