SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '3164194a3b76d0073bdc508ddd2d3821bf215fd528f36e4798148f89160e52f1' 
  AND token = '0Cgv/UqM0EciazJZKSALXWg7fQyzB6nBHi9MLffQ4No=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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