SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '79a76f8124bd1c06e8f7d869bc97d5bc3f2d770b5b46f8eef0868e22ee3ba07d' 
  AND token = 'N5o9XT7oZJ7La2QopK9Y4I3VjbXdfaommadC8IlT3zw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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