SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '8b448df5d62213ffbd4b37a16716c34adb106042e702b39f73abb8ff75b6bb11' 
  AND token = 'XW7KOwl0NJP8xtC+rk/uQV89+F+HSyo711Z6mTsoF98=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00025

JSON explain

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