SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'db9b94d1c37bd8456ef0ee1c8e4c7599b3e4b441812a595af5c458c55d0c4871' 
  AND token = '4GikzTOnaSC4wMxx+SVl6dVXU56zy90cG3uW/ZG0WXA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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